﻿<%@ Page Title="" Language="C#" MasterPageFile="~/UserSite.Master" AutoEventWireup="true" CodeBehind="UserSelect.aspx.cs" Inherits="_2014112107.UserSelect" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder2" runat="server">
    <p>
        当前位置：首页→个人记录→查询记录</p>
    <p>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 根据日期查询：<asp:TextBox ID="txtDate" runat="server"></asp:TextBox>
&nbsp;&nbsp;&nbsp;
        &nbsp;<asp:Button ID="btnSelect" runat="server" OnClick="btnSelect_Click" Text="确认查询" />
    &nbsp;&nbsp;&nbsp;&nbsp;
    </p>
    <p>
        <asp:GridView ID="GridView1" runat="server" BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2" Height="96px" Width="974px">
            <FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
            <HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
            <PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
            <RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
            <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
            <SortedAscendingCellStyle BackColor="#FFF1D4" />
            <SortedAscendingHeaderStyle BackColor="#B95C30" />
            <SortedDescendingCellStyle BackColor="#F1E5CE" />
            <SortedDescendingHeaderStyle BackColor="#93451F" />
        </asp:GridView>
    </p>
    <p>
        <asp:GridView ID="GridView2" runat="server" AllowPaging="True" AutoGenerateColumns="False" DataKeyNames="日期" DataSourceID="SqlDataSource1" Width="976px">
            <Columns>
                <asp:BoundField DataField="日期" HeaderText="日期" ReadOnly="True" SortExpression="日期" />
                <asp:BoundField DataField="项目1" HeaderText="项目1" SortExpression="项目1" />
                <asp:BoundField DataField="支出额" HeaderText="支出额" SortExpression="支出额" />
                <asp:BoundField DataField="项目2" HeaderText="项目2" SortExpression="项目2" />
                <asp:BoundField DataField="收入额" HeaderText="收入额" SortExpression="收入额" />
                <asp:BoundField DataField="备注" HeaderText="备注" SortExpression="备注" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112107ConnectionString %>" SelectCommand="SELECT * FROM [project]"></asp:SqlDataSource>
    </p>
    <p>
        <asp:Label ID="lblInfo" runat="server" ForeColor="Red"></asp:Label>
    </p>
</asp:Content>
